﻿IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tb_project]') AND TYPE in (N'U'))
BEGIN
CREATE TABLE tb_project
(
    Id INT IDENTITY(1,1) NOT NULL,
	ProjectName_Zh_cn varchar(50) NOT NULL,
	ProjectDescription_Zh_cn varchar(255) NOT NULL default(''),
	ProjectImageUrl_Zh_cn varchar(255) NOT NULL default(''),
	ProjectName_Zh_tw varchar(50) NOT NULL,
	ProjectDescription_Zh_tw varchar(255) NOT NULL default(''),
	ProjectImageUrl_Zh_tw varchar(255) NOT NULL default(''),
	ProjectName_En_us varchar(50) NOT NULL,
	ProjectDescription_En_us varchar(255) NOT NULL default(''),
	ProjectImageUrl_En_us varchar(255) NOT NULL default(''),
	ProjectUrl varchar(255) NOT NULL default(''),
    CreateBy VARCHAR(100),
    CreateDate DATETIME DEFAULT(GETDATE()),
    UpdateBy VARCHAR(100),
    UpdateDate DATETIME,
	CONSTRAINT PK_project_Id PRIMARY KEY CLUSTERED (Id)
) 
END
GO
